package com.mp.approvalreq.dao;

import com.mp.approvalreq.entity.Expense;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public interface ExpenseDao {

    /**
     * 批量插入报销/申购套件信息
     *
     * @param expenses
     * @throws SQLException
     */
    void insertBatchExpenses(List<Expense> expenses) throws SQLException;

    /**
     * 删除审批套件信息
     *
     * @param requestId
     * @param companyId
     * @throws SQLException
     */
    void deleteExpensesByRequestId(Integer requestId, Integer companyId) throws SQLException;

    /**
     * 查询审批套件信息
     *
     * @param requestId
     * @return
     * @throws SQLException
     */
    List<Expense> selectExpensesByRequestId(Integer requestId) throws SQLException;

    /**
     * 批量查询审批套件信息
     *
     * @param requestIds
     * @return
     * @throws SQLException
     */
    Map<Integer, List<Expense>> selectExpensesByRequestIds(String requestIds) throws SQLException;
}
